SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE dbo.[DISC_DefaultStampConfigUpdate]
   @ID int,
   @distID varchar(50),
   @name nvarchar(50),
   @description ntext,
   @publisherName nvarchar(50),
   @staticString nvarchar(150),
   @pages nvarchar(max),
   @fontName varchar(50),
   @fontSize float,
   @textRenderingMode tinyint,
   @textColor varchar(6),
   @textStrokeColor varchar(6),
   @strokeWidth float,
   @placeAs int,
   @x varchar(6),
   @y varchar(6),
   @units tinyint,
   @rotate int,
   @opacity tinyint,
   @fontEmbed bit,
   @fontSubset bit,
   @stampType tinyint,
   @textColorSpace tinyint,
   @strokeColorSpace tinyint
AS
BEGIN
	UPDATE [DISC_DefaultStampConfig]
	   SET [PublisherName] = @PublisherName,
		  [staticString] = @staticString,
		  [pages] = @pages,
		  [fontName] = @fontName,
		  [fontSize] = @fontSize,
		  [textRenderingMode] = @textRenderingMode,
		  [textColor] = @textColor,
		  [textStrokeColor] = @textStrokeColor,
		  [strokeWidth] = @strokeWidth,
		  [placeAs] = @placeAs,
		  [x] = @x,
		  [y] = @y,
		  [units] = @units,
		  [rotate] = @rotate,
		  [opacity] = @opacity,
		  [fontEmbed] = @fontEmbed,
		  [fontSubset] = @fontSubset,
		  [stampType] = @stampType,
		  [textColorSpace] = @textColorSpace,
		  [strokeColorSpace] = @strokeColorSpace,
		  [Name] = @Name,
		  [Description] = @Description
	 WHERE [ID] = @ID AND [distID] = @distID
END
GO
